Re: [sqlite] Help for Garbled

2011-03-01 Thread 陈强
>> for example, i insert String filled with gbk bytes and set the String >> charset 'UTF-8' > >What do you mean, "set String charset"? Set how and where? >-- >Igor Tandetnik Hi The String on java side is ok. > for example, i insert String filled with gbk bytes and set the String charset >

Re: [sqlite] Help for Garbled

2011-03-01 Thread Igor Tandetnik
On 3/1/2011 9:49 PM, 陈强 wrote: > How did the sqlite.exe work if insert data through it? > insert gbk string? Most likely. I wouldn't be surprised if these strings came out wrong on Java side, though. > can I insert data like it ? Probably, but I don't think you really want to. It'll be a

Re: [sqlite] Help for Garbled

2011-03-01 Thread 陈强
>Try running this command before starting sqlite.exe, but I'm not sure >this will help: > >mode con cp select=65001 Hi I tried to change the charset of console to utf-8 before, but it didn't work correctly. Because the app will besent to custom, so i want to make sqlite.exe display correctly.

Re: [sqlite] Help for Garbled

2011-03-01 Thread Igor Tandetnik
On 3/1/2011 8:52 PM, 陈强 wrote: > But if i want to make the gbk console show String correctly, what should i do? Try running this command before starting sqlite.exe, but I'm not sure this will help: mode con cp select=65001 There also exists a number of nice graphical tools for working with

Re: [sqlite] Help for Garbled

2011-03-01 Thread 陈强
At 2011-03-02 09:17:48，"Igor Tandetnik" wrote: >On 3/1/2011 8:05 PM, 陈强 wrote: >> At 2011-03-01 20:56:49，"Igor Tandetnik" wrote: >> >>> 陈强 wrote: Why is the Chinese i Selected from SQLIte.exe and jdbc is not different. The

Re: [sqlite] Help for Garbled

2011-03-01 Thread Igor Tandetnik
On 3/1/2011 8:05 PM, 陈强 wrote: > At 2011-03-01 20:56:49，"Igor Tandetnik" wrote: > >> 陈强 wrote: >>> Why is the Chinese i Selected from SQLIte.exe and jdbc is not different. >>> The Chinese from JDBC(rs.getString(index)) is normal but >>> the Chinese from

Re: [sqlite] Help for Garbled

2011-03-01 Thread 陈强
At 2011-03-01 20:56:49，"Igor Tandetnik" wrote: >陈强 wrote: >> Why is the Chinese i Selected from SQLIte.exe and jdbc is not different. The >> Chinese from JDBC(rs.getString(index)) is normal but >> the Chinese from Sqlite.exe (Select data) is Garbled, my

Re: [sqlite] Help for Garbled

2011-03-01 Thread Igor Tandetnik
陈强 wrote: > Why is the Chinese i Selected from SQLIte.exe and jdbc is not different. The > Chinese from JDBC(rs.getString(index)) is normal but > the Chinese from Sqlite.exe (Select data) is Garbled, my environment as list: Console window doesn't know UTF-8. The strings are