question marks instead of latin2 letters

#11

On 11/16/2010 1:57 AM, Jivanmukta wrote:

Quote:

On Nov 12, 11:39 am, Axel Schwenke<axel.schwe... (AT) gmx (DOT) de> wrote:
Jivanmukta<jivanmu... (AT) poczta (DOT) onet.pl> wrote:
I use mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486)
using readline 5.2.
I created database:
CREATE DATABASE ogloszenia CHARACTER SET latin2 COLLATE
latin2_general_ci;

Are you aware that a character set / collation specified for a database
is just a *default*?

Then I imported database tables with data from .sql script created by
another MySQL. I use latin2, Polish characters.

Those tables and the columns in them can use completely different
encoding. SHOW CREATE TABLE ... or SHOW FULL FIELDS FROM ... will tell.

Unfortunately, instead of Polish characters I have question marks.
Please help. Thanks in advance.

RTFM. At least this page:http://dev.mysql.com/doc/refman/5.0/...onnection.html

but better the whole chapter about character set support.

XL

I recreated my database setting SET NAMES latin2 COLLATE
latin2_general_ci before, but it didn't help.

He isn't talking about the database - he's talking about the connection.

As Axel said - RTFM!

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

question marks instead of latin2 letters

comp.databases.mysql comp.databases.mysql

Re: question marks instead of latin2 letters - 11-16-2010 , 06:52 AM