Storing and viewing UTF-8 characters...

CJ Butcher

Hi,

I have a need to pull information from an Oracle 9.2.1 database. It is
storing UTF-8 characters in a varchar2(33) field. I need to be able to pull
these values out and put them in a SQL Server 2000 version of the table with
the UTF-8 characters intact.

Anyone know how to do this...efficien tly? I've tried DTS and the high end
UTF-8 characters get lost in the copy.

Thanks,

CJ

Jul 20 '05 #1

Subscribe Reply

15265

Simon Hayes

"CJ Butcher" <cj@cjbutcher.c om> wrote in message
news:1E******** ***********@new ssvr27.news.pro digy.com...

Hi,

I have a need to pull information from an Oracle 9.2.1 database. It is
storing UTF-8 characters in a varchar2(33) field. I need to be able to pull these values out and put them in a SQL Server 2000 version of the table with the UTF-8 characters intact.

Anyone know how to do this...efficien tly? I've tried DTS and the high end
UTF-8 characters get lost in the copy.

Thanks,

CJ

This KB article may be helpful:

http://support.microsoft.com/default...b;en-us;232580

Simon

Jul 20 '05 #2

CJ Butcher

Thanks for the attempted help Simon.

I've read the article before and am able to get UTF-8 characters into SQL,
the problem is getting them directly from Oracle, seems that DTS converts
the characters to UCS-2 during the transfer...and I don't want it to.

Thanks,

CJ
"Simon Hayes" <sq*@hayes.ch > wrote in message
news:40******** **@news.bluewin .ch...

"CJ Butcher" <cj@cjbutcher.c om> wrote in message
news:1E******** ***********@new ssvr27.news.pro digy.com...
Hi,

I have a need to pull information from an Oracle 9.2.1 database. It is
storing UTF-8 characters in a varchar2(33) field. I need to be able to

pull
these values out and put them in a SQL Server 2000 version of the table

with
the UTF-8 characters intact.

Anyone know how to do this...efficien tly? I've tried DTS and the high end UTF-8 characters get lost in the copy.

Thanks,

CJ

This KB article may be helpful:

http://support.microsoft.com/default...b;en-us;232580

Simon

Jul 20 '05 #3

Erland Sommarskog

CJ Butcher (cj@cjbutcher.c om) writes:

Thanks for the attempted help Simon.

I've read the article before and am able to get UTF-8 characters into SQL,
the problem is getting them directly from Oracle, seems that DTS converts
the characters to UCS-2 during the transfer...and I don't want it to.

Storing Unicode data in SQL Server as UTF-8 is probably not a good idea.
There is no collation that understands UTF-8, so if you could get all
sorts of funny surprises when sorting or comparing UTF-8 data. You could
also get nasty surprises with conversion when retrieving or inserting
data, because the client will think that the data is something else
than what it is.

If you really insist of pushing down the squared peg through the round
hole, your best bet is probably to store the data as binary. Then at
least all bits would be in place, but there would still be a lot to lose.

The way to store Unicode data in SQL Server *is* UTF-16.

--
Erland Sommarskog, SQL Server MVP, so****@algonet. se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Jul 20 '05 #4

CJ Butcher

I read that many days ago. It was relatively useless.

CJ
"Simon Hayes" <sq*@hayes.ch > wrote in message
news:40******** **@news.bluewin .ch...

"CJ Butcher" <cj@cjbutcher.c om> wrote in message
news:1E******** ***********@new ssvr27.news.pro digy.com...
Hi,

I have a need to pull information from an Oracle 9.2.1 database. It is
storing UTF-8 characters in a varchar2(33) field. I need to be able to

pull
these values out and put them in a SQL Server 2000 version of the table

with
the UTF-8 characters intact.

Anyone know how to do this...efficien tly? I've tried DTS and the high end UTF-8 characters get lost in the copy.

Thanks,

CJ

This KB article may be helpful:

http://support.microsoft.com/default...b;en-us;232580

Simon

Jul 20 '05 #5

Similar topics

11471

Easiest way to store and save objects generated by a C++ program?

by: Rolf Hemmerling | last post by:

Hello ! Beginner's question: What ist the easiest way to store and save objects in a file generated by a C++ program, by using the "standard C++ library" and/or "Standard Template Library ( STL )" ? So I would like to generate some objects ( of different classes ) with a C++ program and would like to make it permanent / persistent, so...

C / C++

1468

Viewing/Modifying Link status (new, visited, etc) with ASP

by: - jes | last post by:

Greetings. Using CSS, a programmer can set the color for an href link and a different color for a VISITED href link. Anyone know where this "list" of visited links is stored? Is it accessible (can I read it) with ASP? Is it updateable (can I add new links to the list) with ASP?

ASP / Active Server Pages

2111

need to remove root element when parsing xml doc or storing in database

by: fizzy | last post by:

i am fetching an xml document with the following structure: <?xml version="1.0" encoding="UTF-8"?> <DTCResponse xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="urn:/ows/aws/1.2 http://www.overture.com/schema/dtc/1.2/dtc_response.xsd" xmlns="urn:/ows/aws/1.2" success="true"> <ActionsResponse accountId="123">...

.NET Framework

2010

Code: Viewing Exchange Contacts in ASP.NET

by: George Durzi | last post by:

Hey all, I finally found the necessary resources in the Exchange 2003 SDK to "pull" Contacts out of Exchange and display them on a WebForm. I have been trying to do this forever, and couldn't until the Exchange 2003 SDK came out. Here's the code. Hopefully someone else can find this useful. #region DisplayExchangeContacts private void...

ASP.NET

2182

Problem inserting and storing data from a web form to database

by: hfk0 | last post by:

Hi, I'm new to ASP.net, SQL Server and visual studio.net, and I'm having problem inserting and storing data from a web form to a SQL database. I created a simple ASP.NET web form, a simple SQL database, a database connection (using the SQlDataSource Web Control from the Toolbox), and created the following stored procedure in Visual...

ASP.NET

5289

gridview: "Viewing record x of y"

by: NH | last post by:

I have a girdview with paging enabled. How can I add a message in the footer to say "Viewing records 1-15 of 45" etc Thanks

ASP.NET

1601

Storing images into MySQL DB

by: steelghost | last post by:

I'm currently trying to store images into my DB. But the collation used on my DB is big5, since my client wants this default encoding on their webpage. So to be able read the retreived data I have to use the command mysql_query('SET NAMES big5');. But when I do this, I'm not able to save the images to my DB. When I attempt to, I recieve an...

PHP

5129

Storing and Retreiving hindi asian language text in mysql

by: pushpinderbagga | last post by:

hi I need help in storing and retreiving hindi text from myql... I have done the folowwing ... mysql_query("SET NAMES 'utf8'"); <META http-equiv=Content-Type content="text/html; charset=UTF-8">

MySQL Database

6030

XML encoding problems when storing to sql 2005 database.

by: Bexm | last post by:

Hello I have searched through this forum and it seems some people are having similar problems to me but none of the fixes are fixing mine..! :( I have a table in my database that has two xml fields. I have two bits of generated XML I want to store.. the first one has "<?xml version="1.0" encoding="utf-8" ?>" as its declaration and the...

.NET Framework

10096

problems with storing a custom type in application settings

by: =?Utf-8?B?bWljaGFlbCBzb3JlbnM=?= | last post by:

I have worked with application settings in VS2005 and C# for awhile, but usually with standard types. I have been trying to store a custom container/class/type in an application setting and I have seen erratic results. I am aware of one known defect where user classes do not show up in the list of types on the Property/Settings page in the...

C# / C Sharp

7701

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...

General

7924

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...

C / C++

7677

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...

Windows Server

6284

AI Job Threat for Devs

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...

Career Advice

3653

Trying to create a lan-to-lan vpn between two differents networks

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...

Networking - Hardware / Configuration

3643

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2115

transfer the data from one system to another through ip address

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

C# / C Sharp

1223

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

940

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General