[wxCode-users] Unicode support in DatabaseLayer

[Joseph B. <jb...@um...>]

I'm working on adding Unicode support in DatabaseLayer and a couple 
questions in case anyone here has done something similar.

1) I'm currently encoding strings to UTF-8 before sending them to the 
database and converting strings from UTF-8 into the local character set 
when reading from the database.  Is there a better way?

2) I'd like to add unit tests to make sure that the original Unicode text 
is preserved.  For this I was planning on reading in text files of 
different character set encodings, placing them in the database as strings 
(VARCHAR), reading the values from the database again, and comparing the 
text file to the retrieved value.  Does anyone know a good place to find 
sample Unicode documents for this purpose?

Thanks for taking the time to read this and for any responses.