Uncanaccess and special caracters

dev google-group-archive
1

I work with MDB database (access) ,and ucanaccess driver with Lucee V4.5 or
V5

All files are in ISO-8859


<cfset setEncoding(“URL”, “iso-8859-1”)>
<cfset setEncoding(“FORM”, “iso-8859-1”)>

If I use sql insert of special caracters (like é è à for example),
with “text” fields they are registered with ? (unknown)
with “memo” fields they are registrered correctly (good)

No problem with Coldfusion. (and its Access driver)

Anyone could help with this ? ucanaccess problem or Lucee problem ?
How to solve this. Is there something to fix in the MDB file ?

Thanks, Pierre.

2

I answer it myself :
The Lucee server charset was wrong.
I put ISO-8859-1, (instead of utf-8) and now, all is good.Le mardi 25 octobre 2016 18:27:05 UTC+2, Pierre Larde a écrit :

I work with MDB database (access) ,and ucanaccess driver with Lucee V4.5
or V5

All files are in ISO-8859


<cfset setEncoding(“URL”, “iso-8859-1”)>
<cfset setEncoding(“FORM”, “iso-8859-1”)>

If I use sql insert of special caracters (like é è à for example),
with “text” fields they are registered with ? (unknown)
with “memo” fields they are registrered correctly (good)

No problem with Coldfusion. (and its Access driver)

Anyone could help with this ? ucanaccess problem or Lucee problem ?
How to solve this. Is there something to fix in the MDB file ?

Thanks, Pierre.