0

When I use:

INSERT ... 'ąść' ...

it adds the value 'asc'. Why does this happen? I wrote CHARACTER SET utf8 at end of table declaration, also used COLLATE utf8 polish ci. I also tried: 

INSERT ... VALUE ( N'ąść' )

but it doesn't work. N - for unicode like someone wrote here.

Community
  • 1
  • 1
apocalypse
  • 5,764
  • 9
  • 47
  • 95

1 Answers1

1

Try to issue 

SET NAMES utf8

before INSERT statement.

SET NAMES utf8 in MySQL?

how to select mysql query with foreign language?

Community
  • 1
  • 1
rkosegi
  • 14,165
  • 5
  • 50
  • 83