topic Re: Oracle charset: WE8MSWIN1252 in Alfresco Archive

Oracle charset: WE8MSWIN1252

alex_lu — Wed, 06 Mar 2013 10:30:50 GMT

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

Re: Oracle charset: WE8MSWIN1252

afaust — Wed, 06 Mar 2013 18:07:28 GMT

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

Re: Oracle charset: WE8MSWIN1252

alex_lu — Thu, 07 Mar 2013 11:26:25 GMT

Thanks Axel. I thought about that too.

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