[unixODBC-support] isql trunkates some UTF-8 Text

Hermann-Josef Krings HJ.Krings at business-keeper.com
Fri Jul 6 14:41:34 BST 2007


Am Freitag, 6. Juli 2007 14:32 schrieb Nick Gorham:
> Hermann-Josef Krings wrote:
> >Hello,
> >I use unixODBC 2.2.12 ISQL to retrieve strings from a MaxDB 7.6 Database.
> > The Strings are ecoded UTF-8.
> >The operating system is openSUSE 10.2 with german environment.
> >
> >Retrieving german or english strings is no problem, but strings that
> > contain some polish characters cause ISQL to drop the string and most or
> > all of the Strings that follow.
> >This happens in interactive als well as batch mode, normal output,
> > compressed or html.
> >
> >Do I need to specify the -lx option, if yes what do i have to specify?
> >
> >Thank you
> >
> >Hermann Krings
> >_______________________________________________
> >unixODBC-support mailing list
> >unixODBC-support at easysoft.com
> >http://mail.easysoft.com/mailman/listinfo/unixodbc-support
>
> isql is just a debugging tool. It uses the C standard library to handle
> text, so it is most likely that the stdlib doesn't understand the text.
> Are you running with a UTF-8 locale?

Yes : LC_CTYPE=de_DE.UTF-8
Since other utilities like vim, more .. have no problem, i assume that there 
must be something else.
I also tried: isql <dbname> <user> <pw> -b -w -lpl_PL.UTF-8
No execution error, but also no change in result. 

Hermann Krings



More information about the unixODBC-support mailing list