First to respond to the question about Oracle and CF. We have found that CF
on Windows platform with ODBC drivers linking with Oracle DB on Windows or
Linux boxes had few problems once we chose the native drivers from Oracle.
The principal problem with connecting to an Oracle db was the connection to
the correct library and getting the net8 files correct - particularly with
Linux files.
Where we have fallen afoul is the management of characters with accents
using CF Entreprise 4.5.1 SP2. For some reason asking users to input city
names, for instance, on Windows boxes creates few problems. As soon as we
use the same scripts (see the following) on Linux boxes the search comes
back empty when any name with an accent mark has been inserted. The debug
report from CF shows the select formatted correctly. In effect, the select
seems to be formulated correctly but arrives on Oracle translated badly ...
that the characters with accents are incorrectly reported.
Using SQL+ of Oracle I checked the DB - everything is correct on the DB
(accents, etc.). Oracle's logs show the select attempted in remote as
incorrect basically because the accented characters are incorrect.
The Linux systems all respond to the command locale <CR> indicating italian
as the principal language.
Select seq, nome_progetto, localita_area
FROM
innovazioni
WHERE
nome_progetto IS NOT NULL AND
tipo_ente = '01'
AND LOWER(Localita_area) LIKE '%citt` di castello%'
We would be certainly interested if anyone has any idea why a Linux system
does not manage accented characters like the Windows.
John Forrester
Senior Networking e Systems Engineer
Ancitel Spa
Tel: +39-06-76291206
Cell: +39-0348-7972041
Fax: +39-06-76291328
email: [EMAIL PROTECTED]
..
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
