Hi,
I am currently facing difficulty displaying chinese, japanese, russian
etc. characters. I am using VB 6 and ADO to query the DB2 Version 7.2
unicode database (UTF-8). The resultset that comes back contains
garbage characters for Chinese, Russian etc languages. The english
characters come back fine using ADO.
It seems that DB2 assumes that my application is NOT Unicode
compliant.
How can I make my application unicode compliant so that MSDASQL.1
makes all the right calls to DB2CLI?
I have tried using IBMDADB2 driver as well but the problem is still
there.
I have tried these things:
1) Setting the DB2CODEPAGE instance variable to 1208.
CLI trace shows that Applicaition code page = 1208 and DB2 Code page =
1208
I would have thought that DB2CLI will not do the code page conversion
as both the application and DB2 code pages are the same.
However, reading the CLI trace carefully revealed that DB2 is binding
the query columns using SQL_C_CHAR instead of SQL_C_WCHAR. According
to the DB2 documentation, for UNICODE applications, DB2 will
automatically bind columns using SQL_C_WHAR, thus preventing any data
loss.
I am completly stuck as to how to make my VB application a "UNICODE"
application so that I can retrieve the data in its UNICODE format and
not in ASCII format. My initial hunch is that DB2 is converting the
data to ANSII while fetching the information from the database. The
resultset that comes back to me is in ASCII format. How can I prevent
this?
I have opened a ticket with IBM but they don't have an answer for me
yet.
Any help is appreciated.
Any ideas!!!
Thanks.
--Daman 1 7558
VB6 automatically converts from its internal unicode representation to ASCII
for all external functions, thus DB2 is being told by VB6 to use ASCII even
when you try to access unicode data. This is a VB6 limitation, not a DB2
issue, and there is no official "workaround " as it is part of the VB6
design.
"Daman" <da********@yah oo.ca> wrote in message
news:f4******** *************** ***@posting.goo gle.com... Hi,
I am currently facing difficulty displaying chinese, japanese, russian etc. characters. I am using VB 6 and ADO to query the DB2 Version 7.2 unicode database (UTF-8). The resultset that comes back contains garbage characters for Chinese, Russian etc languages. The english characters come back fine using ADO.
It seems that DB2 assumes that my application is NOT Unicode compliant.
How can I make my application unicode compliant so that MSDASQL.1 makes all the right calls to DB2CLI? I have tried using IBMDADB2 driver as well but the problem is still there.
I have tried these things: 1) Setting the DB2CODEPAGE instance variable to 1208. CLI trace shows that Applicaition code page = 1208 and DB2 Code page = 1208 I would have thought that DB2CLI will not do the code page conversion as both the application and DB2 code pages are the same.
However, reading the CLI trace carefully revealed that DB2 is binding the query columns using SQL_C_CHAR instead of SQL_C_WCHAR. According to the DB2 documentation, for UNICODE applications, DB2 will automatically bind columns using SQL_C_WHAR, thus preventing any data loss.
I am completly stuck as to how to make my VB application a "UNICODE" application so that I can retrieve the data in its UNICODE format and not in ASCII format. My initial hunch is that DB2 is converting the data to ANSII while fetching the information from the database. The resultset that comes back to me is in ASCII format. How can I prevent this?
I have opened a ticket with IBM but they don't have an answer for me yet.
Any help is appreciated.
Any ideas!!!
Thanks.
--Daman This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Miki |
last post by:
Hi.
I have a IIS server with php3 installed. I have SQL server database
and data stored in unicode format (nvarchar fields). In header of my
php I have the meta: <meta HTTP-EQUIV="content-type"
CONTENT="text/html; charset=UTF-8">.
I have the following problem:
- I trie to do a query using ODBC (version 3.525.1022.0) and SQL
|
by: Pettersen, Bjorn S |
last post by:
I've been trying to stay blissfully unaware of Unicode, however now it seems like it's my turn. From the outside it seems like a rather massive subject, so any pointers as to where I should _start_ reading would be appreciated. The usecase is a class:
class path(object):
...
def __str__(self):
return self.pathstr.encode(???)
the question is what to put at ??? to be most useful to programmers/end users?
Background: I've got a...
|
by: Scott Vercuski |
last post by:
Hello All,
I'm having a problem saving/displaying multiple lanaguages on an
ASP page. Here's the general problem I'm having. I have an admin
area of a website that allows a user to enter items in multiple
languages. EX:
NAME LANGUAGE
Trade Show English
商业展览 Chinese
|
by: webdev |
last post by:
lo all,
some of the questions i'll ask below have most certainly been discussed
already, i just hope someone's kind enough to answer them again to help
me out..
so i started a python 2.3 script that grabs some web pages from the web,
regex parse the data and stores it localy to xml file for further use..
at first i had no problem using python minidom and everything concerning
|
by: Bill Nguyen |
last post by:
I'm getting data from a mySQL database (default char set = UTF-8).
I need to display data in Unicode but got only mongolian characters like
this: Phạm Thị Ngọc
I changed the textbox font to Arial Unicode MS but still not working.
Do I need conversion of data stored in mySQL database before displaying?
Thanks
Bill
| |
by: Sithy |
last post by:
Dear All,
Currently we are working on a project by using Visual Studio.net as an
interface, MS-SQL as data store, and ReportViewer 8 as data view. We
want to display our local unicode characters. And it seems that the
display on the report is not correct at all.
For your further understadning, we would like to tell you that we are
working on Cambodian Character (Khmer Unicode). Our characters are some
what different from English. We...
|
by: kev |
last post by:
Hi all,
I have created a database for equipments. I have a form to register the
equipment meaning filling in all the particulars (ID, serial, type,
location etc). I have two buttons at the end of the form which is
submit and cancel. After i have clicked submit, the information is
stored directly into my corresponding database table. My problem here
is i need to retrieve back the information submitted to display all the
data that the...
|
by: coldpizza |
last post by:
Hi!
I am using the built-in Python web server (CGIHTTPServer) to serve
pages via CGI.
The problem I am having is that I get an error while trying to display
Unicode UTF-8 characters via a Python CGI script.
The error goes like this: "UnicodeEncodeError: 'ascii' codec can't
encode character u'\u026a' in position 12: ordinal not in range(128)".
|
by: jackbenimble999 |
last post by:
Hello!
What is the best way to display a EUC-encoded field with Access 2007?
Or, failing that, how do you display a Unicode field as the character
instead of the number? Do I need to use a browser control? I have
created a local web page which successfully displays a Unicode
character when I bring it up using a standard browser, but so far I
haven't been able to figure out how to get the WebBrowser control to
navigate to the page - it...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
| |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |