Greg Obleshchuk wrote: >Hello, >I had this guy email me about a problem about using ISO8859 character . He >has this in the DB >Handhilfsbetätigungssatz > >but when queried using my wrapper it returns Handhilfsbet..tigungssatz > >When using SQLITE.EXE the results are displayed fine. When I debug the code >the char * returned in the call-back event for this column has this >character as value -124 . Which I assume is an overflowed 7 bit value. Can >anyone help me understand how to fix this in the source?
I am not an expert in encodings but just a guess, this might be related to the fact that the "Handhilfsbetätigungssatz" word was typed on another machine using another encoding ? For example, if your wrapper does not enforce the use of ISO-8859-1, then if the user is on a Mac, the characters inserted will use the Mac Roman encoding. Then, if you display it back on Windows, the characters will show differently if you don't convert them. Of course, I might be all wrong here as I am trying to figure that out as well myself :) In my application, I think I will let the user choose which encoding she wants to use (through Preferences for example). The safe way might be to use UTF-8. But this might make the databases bigger ? And there are apparently problems using the UTF-8 version of sqlite with PHP (although I still don't understand what the problems can be ???). Bertrand Mansion Mamasam --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]