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)