http://qs321.pair.com?node_id=11121675

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

Hi Monks,

I have two postgres linux envs,

  1. one with server_enconding sql_ascii
  2. other with server encoding utf8.
Filename name having international chars are getting attached properly in first env but failing it in second env.

What could be possible reason and how it can be solved.

Thank you.

  • Comment on Filename with international chars is failing to attach in the application in postgres Linux env.

Replies are listed 'Best First'.
Re: Filename with international chars is failing to attach in the application in postgres Linux env.
by davido (Cardinal) on Sep 12, 2020 at 18:35 UTC

    Show the relevant portion of your Perl code, in a small self-contained program that includes sample input and the incorrect behavior you are describing. This must be possible to reduce to 30 lines of code or less, if it is a problem with your Perl code. Part of the reason we need to see code is to see how you are handling UTF-8. Another part of the reason is to see how the question relates to Perl at all. As asked, the question seems too vague to be answerable.


    Dave

Re: Filename with international chars is failing to attach in the application in postgres Linux env.
by Anonymous Monk on Sep 14, 2020 at 14:47 UTC
    Your question as posted is not clear enough to answer yet ... "file being attached?" Show us, exactly what you mean – excerpts of what you are trying to do, actual messages that you are receiving. Show us both evidence that it worked and corresponding cases where it didn't.