Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Is it supported Korean language on ADS?

2 posts in ,  Visual Basic General Last posting was on 2009-09-28 07:26:28.0Z
in-nam Hwang Posted on 2009-09-28 02:03:42.0Z
Reply-To: "in-nam Hwang" <inam@dataworks.co.kr>
From: "in-nam Hwang" <inam@dataworks.co.kr>
Newsgroups: advantage.general,advantage.visual_basic
Subject: Is it supported Korean language on ADS?
Date: Mon, 28 Sep 2009 11:03:42 +0900
Lines: 2462
Organization: datawroks
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 124.56.93.92
Message-ID: <4ac01930@solutions.advantagedatabase.com>
X-Trace: 27 Sep 2009 20:02:24 -0700, 124.56.93.92
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!124.56.93.92
Xref: solutions.advantagedatabase.com Advantage.General:11444 Advantage.Visual_Basic:1172
Article PK: 1122847

Hi there.

I am testing ASP program(MS) with Korean datasets on Advantage Database
Server(9.1) with OLE DB provider.

provider connection string;
Provider=Advantage OLE DB Provider;User ID=adssys;Password=;Data
Source=D:\ads\TESTDB1.ADD;Advantage Server Type=ADS_REMOTE_SERVER;

Insert statement with Korean data;
ex)
INSERT INTO BOARD (title) VALUES('test') [ok]
INSERT INTO BOARD (title) VALUES('Çѱ۷Î') [Error]

Error;
Advantage OLE DB Provider (0x80040E14)
Error 7200: AQE Error: State = 42000; NativeError = 2113; [iAnywhere
Solutions][Advantage SQL Engine]Unexpected end of SQL statement Insert into
BOARD (title) VALUES('Çѱ۷Î')
/euc.asp, line 20


So, I am wondering whether ADS is supporting double bytes charecter
sets(Korean) with OLE DB provider?

Advantage Data Architect was good working for above SQLs (including Korean
data), but ASP was not working.
In SQL utility
Insert, Update, Select : ok
In ASP with OLE
Select : ok
insert, update : failed

attached file: Advantage configuration Utility

Thanks in advance,
In-Nam, Hwang

setinfo_language.JPG
setinfo_installationInfo.JPG

Joachim Duerr (ADS) Posted on 2009-09-28 07:26:28.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: Is it supported Korean language on ADS?
Newsgroups: advantage.general,advantage.visual_basic
References: <4ac01930@solutions.advantagedatabase.com>
Date: Mon, 28 Sep 2009 09:26:28 +0200
User-Agent: XanaNews/1.19.1.194
X-Face: u2p+</,mb|Ah!x!/qxX5q0t:O~.<1&JzwNHYhSqcviY{~&|iDc"U.Je1A.ZeHR`d;;y#R
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 10.56.66.155
Message-ID: <4ac064ce@solutions.advantagedatabase.com>
X-Trace: 28 Sep 2009 01:25:02 -0700, 10.56.66.155
Lines: 12
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.56.66.155
Xref: solutions.advantagedatabase.com Advantage.General:11447 Advantage.Visual_Basic:1173
Article PK: 1122849


in-nam Hwang wrote:

>So, I am wondering whether ADS is supporting double bytes charecter
>sets(Korean) with OLE DB provider?

support for Unicode is currently available as a preview only. It will
be supported in ADS 10 (Q1/2010).

--
Joachim Duerr
Advantage Presales
check out my new ADS book on http://www.jd-engineering.de/adsbuch