I am using Windows 2003 Server English Version. I wanna store the big-5
data so I install the sql server 2000 as if i install it in the Windows
2000 with Server Collation of the Chinese_Taiwan_ Stroke_CL_AS.
However, the data are stored into the database server in unicode
instead of big-5 in that of windows 2000 OS.
I would like to ask how i can set so that the Sql Server 2000 can store
the big-5 data 6 2567
(mi**********@g mail.com) writes: I am using Windows 2003 Server English Version. I wanna store the big-5 data so I install the sql server 2000 as if i install it in the Windows 2000 with Server Collation of the Chinese_Taiwan_ Stroke_CL_AS. However, the data are stored into the database server in unicode instead of big-5 in that of windows 2000 OS.
I would like to ask how i can set so that the Sql Server 2000 can store the big-5 data
First of all, my knowledge and experience of Chinese and its character
sets is very limited, so bear with me.
I was under the impression that for non-Unicode characters sets, East
Asian languages are stored in varchar as double-byte character sets.
Unicode is stored in nvarchar. So you would probably use varchar for
your data. Could this be the answer?
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
I am using the varchar for the fields of table which i wanna save big-5
data.
When i entered the chinese data, the data can be saved. But when i read
the data from the web boswer (ie. IE ), i need to change the encoding
from unicode instead of big-5 in order to viewing it
Is it due to the language of the OS (ie. WIndows 2003)?
(mi**********@g mail.com) writes: I am using the varchar for the fields of table which i wanna save big-5 data.
When i entered the chinese data, the data can be saved. But when i read the data from the web boswer (ie. IE ), i need to change the encoding from unicode instead of big-5 in order to viewing it
Is it due to the language of the OS (ie. WIndows 2003)?
Hm, if the columns in the database are varchar, then you just cannot
get Unicode into them. So my guess is that you do have Big-5 in the
database, and then something happens on the way to the web browser.
You could verify this by looking in Qurey Analyzer and doing a
SELECT on the table. If it looks OK, then I would guess it is
Big-5. Do run it even further you could do:
select convert(varbina ry, big5col)
and the see whether the codes are Big-5 or Unicode. (This presumes that
you actually knows the codes for some characters.)
If my theory is correct that the data in the database is Big5, then
we need to find out why you get Unicode in the browser. Unfortunately,
I know almost as little about web servers as I know Chinese.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
(mi**********@g mail.com) writes: I am using the varchar for the fields of table which i wanna save big-5 data.
When i entered the chinese data, the data can be saved. But when i read the data from the web boswer (ie. IE ), i need to change the encoding from unicode instead of big-5 in order to viewing it
Is it due to the language of the OS (ie. WIndows 2003)?
Hm, if the columns in the database are varchar, then you just cannot
get Unicode into them. So my guess is that you do have Big-5 in the
database, and then something happens on the way to the web browser.
You could verify this by looking in Qurey Analyzer and doing a
SELECT on the table. If it looks OK, then I would guess it is
Big-5. Do run it even further you could do:
select convert(varbina ry, big5col)
and the see whether the codes are Big-5 or Unicode. (This presumes that
you actually knows the codes for some characters.)
If my theory is correct that the data in the database is Big5, then
we need to find out why you get Unicode in the browser. Unfortunately,
I know almost as little about web servers as I know Chinese.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
I try the method you mentioned in both MS SQL Server in Windows 2000
server and Windows 2K3.
select convert(varbina ry, big5col)
It is found that the binary is the same.
I have found out that if you add the following in the heading of the
page,
this page can show the big-5 character.
<%@ codepage=950 %>
As the string stored in database is in unicode format, if you set the
codepage as big-5 format, the data will be changed as big-5 and show in
the webpage.
Thank you for your great sugegstion
Ref: Chinese-simpified version: http://www.evget.com/articles/evget_1092.html
Erland Sommarskog 寫道: (mi**********@g mail.com) writes: I am using the varchar for the fields of table which i wanna save big-5 data.
When i entered the chinese data, the data can be saved. But when i read the data from the web boswer (ie. IE ), i need to change the encoding from unicode instead of big-5 in order to viewing it
Is it due to the language of the OS (ie. WIndows 2003)?
Hm, if the columns in the database are varchar, then you just cannot get Unicode into them. So my guess is that you do have Big-5 in the database, and then something happens on the way to the web browser.
You could verify this by looking in Qurey Analyzer and doing a SELECT on the table. If it looks OK, then I would guess it is Big-5. Do run it even further you could do:
select convert(varbina ry, big5col)
and the see whether the codes are Big-5 or Unicode. (This presumes that you actually knows the codes for some characters.)
If my theory is correct that the data in the database is Big5, then we need to find out why you get Unicode in the browser. Unfortunately, I know almost as little about web servers as I know Chinese.
-- Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
(mi**********@g mail.com) writes: I try the method you mentioned in both MS SQL Server in Windows 2000 server and Windows 2K3.
select convert(varbina ry, big5col)
It is found that the binary is the same.
I have found out that if you add the following in the heading of the page, this page can show the big-5 character.
<%@ codepage=950 %>
As the string stored in database is in unicode format, if you set the codepage as big-5 format, the data will be changed as big-5 and show in the webpage.
Thank you for your great sugegstion
I'm glad to have been to help about something I hardly know at all!
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Michael Klatt |
last post by:
I am trying to write an iterator for a std::set that allows the
iterator target to be modified. Here is some relvant code:
template <class Set> // Set is an instance of std::set<>
class Iterator
{
public :
typedef typename Set::value_type T;
typedef typename Set::iterator SetIterator;
Iterator(Set& container, const SetIterator& it);
|
by: snnn |
last post by:
On the book <Generic Programming and the STL>( Matthew . H . Austern ),this function is defined as
iterator set::begin() const.
However, why should a const object returns a non-const iterator?
Then, I found, in this book, the semantic of set::iterator is defined as same as set::const_iterator. Both of them must be const!
I tried to read the source of GNU STL(version 3.4.1).They were using a red-black tree to implant it (std::set has a...
|
by: uclamathguy |
last post by:
I am working on connected component analysis, but that is irrelevant. I
have a mapping containing ints as the keys and sets of ints as the
"values."
Given an integer, I need to iterate through the map, which means I must
iterate through all of the sets in the map. I need an iterator that
points to the set where the integer was found. How can I do this? What
will the type of this iterator be? Can you help me with a code snippet?
|
by: Prawit Chaivong |
last post by:
Hi, gurus
Is it safe to do this in function?
'return &(*iterator)';
And iterator is std::set<something>::iterator
Regards,
|
by: teddysnips |
last post by:
I am trying to insert a row into a table using a stored procedure and I
get the following error if I try this from QA:
INSERT failed because the following SET options have incorrect
settings: 'ANSI_NULLS., QUOTED_IDENTIFIER'.
If I try to run this from Microsoft Access, I get a slightly different
error:
INSERT failed because the following SET options have incorrect
| |
by: Yomus |
last post by:
hi
Does anyone know how to use the get and set command
thanks
|
by: ucasesoftware |
last post by:
If i have this property
Dim m_name as string
Property name() as string
Get
return m_name
end Get
Set (byval Value as string)
m_name = Value
|
by: Yuri CHUANG |
last post by:
This is a example from a textbook,but there are some strange error that
I don't understand.Could anyone give me some help to realize the
operations on set.Thank you very much:-)
(I compile it with Dev C++ 4.9.9.2)
#include<iostream>
#include<set>
#include<string>
#include <algorithm>
|
by: desktop |
last post by:
I have implemented a red-black tree which is used for std::set.
In the C++ standard 3 different insert methods are specified for the
associative container. But as i see it insert adds an object to the set
based on a key. But where does the key come from?
If I make my own object I don't specify any unique key that insert uses
to place the object.
Does the insert call generate some unique key that it uses each time an
|
by: kuangye |
last post by:
Hi, all.
Is there any library supporting set operation such as union,
intersection, difference on sets of integer numbers.
|
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.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 projectplanning, coding, testing, and deploymentwithout 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: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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
| |