Re: MS ODBC encoding issue

2014-04-12 Thread FrankLike
Sam you should put th ODBC code to the github.com , let all world to see your hard work! Frank

Re: MS ODBC encoding issue

2013-01-23 Thread Regan Heath
On Wed, 23 Jan 2013 04:09:01 -, Sam Hu samhudotsa...@gmail.com wrote: for windows console show Chinese character issue,I've solved and posted on the forum before.Please refer to below link:

Re: MS ODBC encoding issue

2013-01-23 Thread Regan Heath
On Wed, 23 Jan 2013 04:41:11 -, Sam Hu samhudotsa...@gmail.com wrote: I've tested and the Chinese character issue really fixed! But I have two more issues here. 1.for connect with DSNless string function provided by my original code as below,I can not make it to connect successfully with

Re: MS ODBC encoding issue

2013-01-22 Thread Sam Hu
On Thursday, 17 January 2013 at 18:36:16 UTC, Regan Heath wrote: On Mon, 14 Jan 2013 10:02:04 -, Regan Heath re...@netmail.co.nz wrote: Ok, solved the issue I think. Appreciatd all the help and am very excited that it finaly works,WOW! Now I can see (in Visual-D debugger) the Chinese

Re: MS ODBC encoding issue

2013-01-22 Thread Sam Hu
I've tested and the Chinese character issue really fixed! But I have two more issues here. 1.for connect with DSNless string function provided by my original code as below,I can not make it to connect successfully with really database file.Don't now why yours works. bool connect(string

Re: MS ODBC encoding issue

2013-01-17 Thread Regan Heath
On Mon, 14 Jan 2013 10:02:04 -, Regan Heath re...@netmail.co.nz wrote: I'm more than happy to upload the database file here,but I can't find how to.May I have your mail address?Appreciated for all the help! My email address in the from is valid: regan at netmail dot co dot nz Ok,

Re: MS ODBC encoding issue

2013-01-14 Thread Regan Heath
I'm more than happy to upload the database file here,but I can't find how to.May I have your mail address?Appreciated for all the help! My email address in the from is valid: regan at netmail dot co dot nz -- Using Opera's revolutionary email client: http://www.opera.com/mail/

Re: MS ODBC encoding issue

2013-01-13 Thread Sam Hu
On Monday, 31 December 2012 at 11:01:17 UTC, Regan Heath wrote: On Mon, 24 Dec 2012 07:18:51 -, Sam Hu samhudotsa...@gmail.com wrote: On Friday, 21 December 2012 at 15:20:39 UTC, Regan Heath wrote: On Wed, 19 Dec 2012 06:33:16 -, Sam Hu samhudotsa...@gmail.com wrote: On Monday, 10

Re: MS ODBC encoding issue

2012-12-31 Thread Regan Heath
On Mon, 24 Dec 2012 07:18:51 -, Sam Hu samhudotsa...@gmail.com wrote: On Friday, 21 December 2012 at 15:20:39 UTC, Regan Heath wrote: On Wed, 19 Dec 2012 06:33:16 -, Sam Hu samhudotsa...@gmail.com wrote: On Monday, 10 December 2012 at 14:43:08 UTC, Regan Heath wrote: Ahh, of

Re: MS ODBC encoding issue

2012-12-23 Thread Sam Hu
On Friday, 21 December 2012 at 15:20:39 UTC, Regan Heath wrote: On Wed, 19 Dec 2012 06:33:16 -, Sam Hu samhudotsa...@gmail.com wrote: On Monday, 10 December 2012 at 14:43:08 UTC, Regan Heath wrote: Ahh, of course. Now I'm having linking issues :p I'm using VisualD and I've added

Re: MS ODBC encoding issue

2012-12-21 Thread Regan Heath
On Wed, 19 Dec 2012 06:33:16 -, Sam Hu samhudotsa...@gmail.com wrote: On Monday, 10 December 2012 at 14:43:08 UTC, Regan Heath wrote: Ahh, of course. Now I'm having linking issues :p I'm using VisualD and I've added odbc32.lib to the right place, but some symbols are still missing -

Re: MS ODBC encoding issue

2012-12-18 Thread Sam Hu
On Monday, 10 December 2012 at 14:43:08 UTC, Regan Heath wrote: Ahh, of course. Now I'm having linking issues :p I'm using VisualD and I've added odbc32.lib to the right place, but some symbols are still missing - specifically the W versions. I've dumped the symbols in the DMC odbc32.lib

Re: MS ODBC encoding issue

2012-12-10 Thread Regan Heath
On Fri, 07 Dec 2012 00:27:57 -, Sam Hu samhudotsa...@gmail.com wrote: On Thursday, 6 December 2012 at 16:44:01 UTC, Regan Heath wrote: On Thu, 06 Dec 2012 01:26:32 -, Sam Hu samhudotsa...@gmail.com wrote: Known issues: Under console reading Access table recordsets works fine

Re: MS ODBC encoding issue

2012-12-06 Thread Regan Heath
On Thu, 06 Dec 2012 01:26:32 -, Sam Hu samhudotsa...@gmail.com wrote: Known issues: Under console reading Access table recordsets works fine ,inserting a new record which contains only English characters works fine as well,but inserting new record which contains Chinese character will

Re: MS ODBC encoding issue

2012-12-06 Thread Sam Hu
On Thursday, 6 December 2012 at 16:44:01 UTC, Regan Heath wrote: On Thu, 06 Dec 2012 01:26:32 -, Sam Hu samhudotsa...@gmail.com wrote: Known issues: Under console reading Access table recordsets works fine ,inserting a new record which contains only English characters works fine as

Re: MS ODBC encoding issue

2012-12-05 Thread Regan Heath
On Wed, 05 Dec 2012 03:29:50 -, Sam Hu samhudotsa...@gmail.com wrote: On Tuesday, 4 December 2012 at 10:05:16 UTC, Nathan M. Swan wrote: I've never used ODBC before, but a quick scan of the MSDN docs suggests that you should use SQL_C_WCHAR instead, maybe using some D wstring

Re: MS ODBC encoding issue

2012-12-05 Thread Sam Hu
On Wednesday, 5 December 2012 at 11:33:16 UTC, Regan Heath wrote: On Wed, 05 Dec 2012 03:29:50 -, Sam Hu samhudotsa...@gmail.com wrote: On Tuesday, 4 December 2012 at 10:05:16 UTC, Nathan M. Swan wrote: I've never used ODBC before, but a quick scan of the MSDN docs suggests that you

Re: MS ODBC encoding issue

2012-12-05 Thread Sam Hu
Known issues: Under console reading Access table recordsets works fine ,inserting a new record which contains only English characters works fine as well,but inserting new record which contains Chinese character will crash; If calling the fetchAll in a DFL gui form and try to display the

MS ODBC encoding issue

2012-12-04 Thread Sam Hu
Greetings! Any help would be much appreicated in advance as I've really struggled for quite long time! I wrote a class wrapper for MS ODBC Access database.When I try to run query on an Access database file,all fields contains English character are fine with the result,but for those Asian

Re: MS ODBC encoding issue

2012-12-04 Thread Nathan M. Swan
On Tuesday, 4 December 2012 at 07:59:40 UTC, Sam Hu wrote: Greetings! Any help would be much appreicated in advance as I've really struggled for quite long time! I wrote a class wrapper for MS ODBC Access database.When I try to run query on an Access database file,all fields contains

Re: MS ODBC encoding issue

2012-12-04 Thread Sam Hu
On Tuesday, 4 December 2012 at 10:05:16 UTC, Nathan M. Swan wrote: I've never used ODBC before, but a quick scan of the MSDN docs suggests that you should use SQL_C_WCHAR instead, maybe using some D wstring functions too. BTW, convert sql.ptr - std.string.toStringz(sql); this is good

Re: MS ODBC encoding issue

2012-12-04 Thread Sam Hu
On Tuesday, 4 December 2012 at 10:05:16 UTC, Nathan M. Swan wrote: I've never used ODBC before, but a quick scan of the MSDN docs suggests that you should use SQL_C_WCHAR instead, maybe using some D wstring functions too. BTW, convert sql.ptr - std.string.toStringz(sql); this is good