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]

Reply via email to