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)
