Monday, March 19, 2012

Convert to Unicode

Hi all
I have an Sql2k database with SQL Server Sort Order 185 on Code Page 1252
for non-Unicode Data
Now customers from latvia needs to use this database concurrently , is it
possible to convert the tables to Unicode when it is already running live?
Best regards
Henrik Hasselblad
SYSteamThis is a multi-part message in MIME format
--=_NextPart_000_61137148
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
You will have to change all varchars to nvarchars. You will need to
check that no string is bigger than 4000 chars and that you don't
violate the 8060 byte max rowsize.
Changing the values via alter column may cause problems too.
You can chnage the collation via alter database.
Nigel Rivett
www.nigelrivett.net
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
--=_NextPart_000_61137148
Content-Type: text/html; name="_alt.0"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment; filename="_alt.0"
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4=2E0= Transitional//EN">
&

Careful=2E Is transdate your= partitioning
column or is month? Make sure to include the partitioning= column in the
WHERE clause=2E
-- Tom
----=--Thomas
A=2E Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist,= SQL Server
ProfessionalToronto, ON Canadahref=3D"www=2Epinnaclepublishi=">http://www=2Epinnaclepublishing=2Ecom/sql">www=2Epinnaclepublishi=ng=2Ecom/sql
"George" wrote in
message ne=ws:E5C82E40-6AE6-444D-B939-FC55D20B19C4@.microsoft=2Ecom=2E=2E=2EThanks
a lot for Tom and Dan=2E I have changed the partition tables= divided by month, and
created the table with CHECK constraint=2E My script only= references V_use once
per query, and, even as simple as 'select * from v_use where= transdate between
@.d1 and @.d2' will call every base table, although most of them= only takes 1%~2%
total cost=2E Thanks again=2E
--=_NextPart_000_61137148--

No comments:

Post a Comment