RE: cannot import data manually on sql server 2005 because of collatio
- From: changliw@xxxxxxxxxxxxxxxxxxxx (Charles Wang[MSFT])
- Date: Mon, 31 Mar 2008 05:11:04 GMT
Hi Betty,
I understand that you could not upgrade your SQL Server 2000 database to
SQL Server 2005 due to the error "The LocaleID 1028 is not installed on
this system.".
If I have misunderstood, please let me know.
I think that the problem is that there is no language support for
Chinese_Taiwan on your server on which your SQL Server 2005 is running.
Your original collation of your SQL Server 2000 database is a Windows
collation, and this requires that the related language and locale must be
installed on your system. I recommend that you first install the language
collection via the following steps:
From Start menu, select Settings then Control Panel, start RegionalOptions, click on Languages tab, in Supplemental language support box,
check the checkbox of the language collection "Install files for East
Asian languages" and then click OK. After this, additional files will be
copied to your machine. You may need to provide the Windows system CD or
the network share name. After reboot, support for new languages will become
available.
Regarding language collection and locale, you may refer to this article:
Windows XP/Server 2003 - List of Locale IDs, Input Locale, and Language
Collection
http://www.microsoft.com/globaldev/reference/winxp/xp-lcid.mspx
Additionally if you have no need to use the collation
Chinese_Taiwan_Stroke_CI_AS for your database, I recommend that you change
the database collation to a common collation, such as Latin1_General. You
may also want the following references:
Setting and Changing the Database Collation
http://msdn2.microsoft.com/en-us/library/ms175835.aspx
Windows Collation Name
http://msdn2.microsoft.com/en-us/library/aa226047(SQL.80).aspx
How to transfer a database from one collation to another collation in SQL
Server
http://support.microsoft.com/kb/325335
Hope this helps. If you have any other questions or concerns, please feel
free to let me know.
Best regards,
Charles Wang
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================
.
- References:
- Prev by Date: RE: cannot import data manually on sql server 2005 because of collatio
- Next by Date: RE: import data from a flat file into sql server 2005 table manually
- Previous by thread: RE: cannot import data manually on sql server 2005 because of collatio
- Index(es):
Relevant Pages
|
