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,584
  • 9
  • 44
  • 90

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
  • 13,358
  • 5
  • 49
  • 82