10.08.2012 18:39, Adriano dos Santos Fernandes wrote: >> >The function to get the system charset is nl_langinfo(CODESET). Man page >> >says: >> > >> >CODESET (LC_CTYPE) >> > Return a string with the name of the character encoding used in >> >the selected locale, such as "UTF-8", "ISO-8859-1", or "ANSI_X3.4-1968" >> >(better known as US-ASCII). This is the same string that you get >> > with "locale charmap". For a list of character encoding names, >> >try "locale -m", cf. locale(1). >> > >> >My related env. var is (only it): >> >LANG=pt_BR.UTF-8 >> > >> >And locale charmap gives: >> >UTF-8 >> > >> >Now if I try to connect to localhost:database_some_non_ascii_characters, >> >I get: >> > >> >Statement failed, SQLSTATE = 08001 >> >Invalid connection string >> >-Cannot transliterate character between character sets >> >-Invalid or incomplete multibyte or wide character >> > >> >While without localhost: prefix it works (in isql). >> > >> >I removed setlocale from isql, and then the same error happens with >> >embedded. >> > >> >Even if I export LC_CTYPE=$LANG it does not work. >> > >> > > I forgot to say: on the problematic case, nl_langinfo is returning > "ANSI_X3.4-1968".
When you are connecting to database with non-ascii characters with ascii connection charset it is natural to receive error, no?.. -- WBR, SD. ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
