Member Avatar for xxmp

Hello
I have a form that a user insert some input

form accept-charset='UTF-8' action="addcommentcheck.jsp" method="post" id="addcommentid">
...
</form>

and at addcommentcheck.jsp i do
request.setCharacterEncoding("UTF-8");
But when i try to insert it to database the only thing that i insert is ????? When i show to the user the input i can see the correct input but when i insert to database i have the ??? What i am doing wrong?
Thank you very much

  • 3 Contributors
  • 4 Replies
  • 217 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by xxmp
Member Avatar for pritaeas

What collation is your database using?

Member Avatar for xxmp

how do i change the collation of my database? I want to change it to utf8_general_ci or to utf8_unicode_ci? What is the difference? Is there any command to change the database collation?

Edited by peter_budo because: Removed code tag formatting
Member Avatar for xxmp

thank you very much

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.