Opened 10 years ago

Closed 10 years ago

#430 closed bug (fixed)

Wrong encoding of file names

Reported by: toromand Owned by: Blucecio
Priority: minor Milestone:
Component: Core Version: 6.8.4
Keywords: Cc:

Description

When files are uploaded
examples;
Doc_šđč枊ĐČĆŽ.txt (Serbian Latin)
Doc_љњшђчћжџЉЊШЂЧЋЖЏ.txt (Serbian Cyrillic)
(and I guess Croatian latin as well)

Filenames are shown as:
Doc_š???žŠ???Ž.txt
Doc_????????????????.txt

Downloaded file from the repository after have filenames:
Doc_š---žŠ---Ž.txt
Doc_----------------.txt

File for testing are attached.

Best regards,
Dragan

Change History (7)

comment:1 Changed 10 years ago by car031

  • Milestone 7.0 deleted
  • Priority changed from Major to Trivial

comment:2 Changed 10 years ago by Blucecio

  • Owner set to Blucecio
  • Priority changed from Trivial to Minor
  • Status changed from new to accepted

comment:3 Changed 10 years ago by Blucecio

This is not a LD bug, but simply you should create the db schema using the appropriate character set and collation.

This is the create statement for MySQL 5.0.22

CREATE DATABASE logicaldoc DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

As regards the jdb connection url there is no need to add additional parameters, they still would not be taken into consideration.
Your jdbc url should be just:

jdbc.url=jdbc:mysql://localhost:3306/logicaldoc
Version 0, edited 10 years ago by Blucecio (next)

comment:4 Changed 10 years ago by Blucecio

See also the general configuration of your MySQL as described in our Linux documentation
Installing on Linux - Prepare the Database

comment:5 Changed 10 years ago by toromand

Thanks,
I will try and report back.

comment:6 Changed 10 years ago by toromand

The problem is resolved. I have manually convert the tables to utf8 and reconfigured default MySQL settings.
It is working now.

Thanks!

comment:7 Changed 10 years ago by toromand

  • Resolution set to fixed
  • Status changed from accepted to closed
Note: See TracTickets for help on using tickets.