Hi all, I guess this guery of mine is no longer related to sqlite, but maybe somebody has encountered this problem before and can help me.
I have a Postgresql database with encoding set to EUC_JP. Then I have a sqlite database that is being updated every 10 minutes from data and dumps from PostgreSQL db. One update is through files dump from the Postgresql. In this case, Japanese characters are displayed fine. The updating is done by reading those files dump from PostgreSQL then calling sqlite3_exec with the file content as parameter. Another is through a c program that connect to the PostgreSQL db then query data in a table that contains SQL statement update then calling sqlite3_exec with the queried SQL statement as parameter. This is where the problem occurs. The result is the data is corrupted and show garbage. Does anybody have a module to handle this? Thanks. Sincerely, Ryan Bel
