RE: Installing using utf-8 and mssql server?

SQL2005 (even the Express edition -- See
http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx)
definitely handles UTF8 much better than the 2000 edition.  There should be
more info in MSDN.

  _____  

From: Michel Romy [mailto:[email protected]] 
Sent: Tuesday, September 27, 2005 11:17 AM
To: [email protected]
Subject: Re:Installing using utf-8 and mssql server?


Hi Lars/Ghislain,

MSSQL is not very UTF8 friendly, you can check this page from the microsoft
Kbase for more info : http://support.microsoft.com/kb/232580/EN-US/ .

Basically as I don't see any of the 5 "options" proposed by MS to be a real
option with Jahia, I'm afraid you will have to go with another DB if UTF8 is
a must-have.

Michel




Hi!
 
I'm using PostgreSQL 7.4.7.000 and when I create my DB instance I specify
that the encoding is UTF-8 for this DB instance with some option in command
line.
 
Perhaps is there the same options on MS SQLServer when you create your DB
instance with the wizards.

  _____  

  
> Hi!
>  
> We are doing some test installations for a customer and try to check the
UTF-8 compliance checkbox but we always get the "This database seems to be
not UTF-8 compliant" message.
>  
> I checked the database and saw that the test table (jahia_db_test) has a
nvarchar(255)  column. I also browsed the source code to find out what type
of checking that failed and it seems like it is a write followed by a select
and than an equal string test (some latin, cyrillic and chinese characters).
>  
> Is there anybody out there which has successfully installed jahia with the
UTF8 checkbox checked in combination with MSSQL Server?
>  
>  
> regards
> /Lars Hagrot
>  
>  
>  
 
 
Ghislain CUSSONNEAU
DIRR/DPIL/CIS
CAP 44, Rue Marcel Sembat
44000 Nantes
02 51 84 48 80
CRIL Technology
Technoparc de l'Aubinière
44000 Nantes
02 51 89 64 50


Accédez au courrier électronique de La Poste : www.laposte.net ;
3615 LAPOSTENET (0,34 /mn) ; tél : 08 92 68 13 50 (0,34/mn)