0

my clients copy and paste greater or less than symbol from Microsoft Word into my Java web application. I use IBM DB2 database. But the symbol shows in empty squeare in my select result.

What have I tried?
Inserting greater/less than or equal symbol into SQL Server database

I tried above link, insert some value but it didn't insert value.

I thought I can replace that sign with >= but I don't want to struggle. So how can I achieve this problem?

Community
  • 1
  • 1
PeerNet
  • 855
  • 1
  • 16
  • 31
  • `INSERT INTO TABLE (column1) VALUES ('<'),('>')` works just fine for me. Maybe you should try posting some real details (the code point that's failing, some app code, and database details including version, platform, codepage) about the problem. – Ian Bjorhovde Feb 15 '17 at 15:52
  • Greater than equal symbol, sorry for my wrong title – PeerNet Feb 15 '17 at 16:08
  • OK, but you'll still need to post a bunch more details. – Ian Bjorhovde Feb 15 '17 at 17:41
  • 1
    You need to know how your database was created and what character set it is using. If you did not create it with a character set that supports that symbol then you need to insert a CLOB or a BLOG column to support it. – Hogan Feb 15 '17 at 21:26

0 Answers0