Akopia Akopia Services

[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date ][Minivend by thread ]

[mv] Importing text files to SQL database converts some characters to dots (e.g. §)



******    message to minivend-users from Sakari Ailus <sakari.ailus@nic.fi>     ******

Hi.

When Minivend 4.04 imports text files to SQL database, it translates
some characters to dots (.). These are characters such as ö, ä and å,
(everything >= 128 I think) and some other characters too (e.g. §-sign).
Minivend 3.14 doesn't do this.

I took $VENDROOT/lib/Vend/Data.pm and $VENDROOT/lib/Vend/Table/* from
Minivend 3.14 to Minivend 4.04 and with small modifications got Minivend
starting almost fine and importing text files correctly. (Normal SQL
searches caused some ugly uninformative errors and I think this might be
a bug in Minivend 4.04, which is why I'm writing this.) I couldn't find
out what in those files does the "translation".

Other relating software I'm using (haven't changed between Minivend's
versions): Debian GNU/Linux 2.1, Perl 5.005_03, DBI 0.92, DBD::Pg 0.73
and PostgreSQL 6.3.2. I know DBI and DBD::Pg modules are fairly old but
as they work fine with Minivend 3.14 I haven't updated them.

Has anyone else noticed this?

Thanks,

-- 
Sakari Ailus
sakari.ailus@nic.fi
-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list


Search for: Match: Format: Sort by: