Oracle charset: WE8MSWIN1252

[alex_lu]

Hi,

Alfresco doc says oracle db MUST be created with charset AL32UTF8. However, my client created a db with charset WE8MSWIN1252. Does anyone know any potential problems that may be caused by different chart?

The only potential problem I can think of is internationalisation.

Thanks

[afaust]

Hello,

that is a rather big potential problem. I don't know what types of contents your client wants to manage with Alfresco, but if the managed objects have metadata with unsupported characters, you'll quickly have an acceptance problem on your hands if users can't find their documents or can't read the metadata on the web UI.

<a href="stackoverflow.com/questions/1200063/why-does-anyone-use-an-encoding-other-than-utf-8#1200126">Answer to why anyone would use an encoding other than unicode</a> (I especially like the first sentence)

Regards
Axel

[alex_lu]

Thanks Axel. I thought about that too.

Managed to convince the client to use UTF-8 at the end.