Subject How to use non-ascii chars in identifiers in isql?
Author Kjell Rilbe

I have a table named "Företag" and a column  named "Löpnr" in a database with all char/varchar columns utf8 and default charset utf8.

I use isql to connect and specify -ch utf8, which i think should result in connection charset utf8. (Correct?)

But it doesn't work. Whenever I try to issue sql that contains an identifier with a non-ascii char, e.g. "ö", it gives me "arithmetic exception, numeric overflow, or string truncation\n-Cannot transliterate character between character sets".

Also, when I select data containing such chars I would expect isql to transliterate them to my client charset (oem850 i believe in Windows cmd with Swedish locale), the characters are output as raw utf8, resulting in 'Ã-', 'ö' and the like.

So how am I supposed to work at all with this database through isql?Or is isql not intended to work with non-ascii characters at all? (Would seems a bit odd...)

Kjell Rilbe
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64