| |

VerySource

 Forgot password?
 Register
Search
View: 809|Reply: 8

Questions about database Chinese fields?

[Copy link]

2

Threads

9

Posts

6.00

Credits

Newbie

Rank: 1

Credits
6.00

 China

Post time: 2020-2-7 15:30:01
| Show all posts |Read mode
from GiisQueryConfig where tableDesc = 'Weather Table' order by fieldName
from GiisQueryConfig where tableName = 'SWeather' order by fieldName
Above are two sentences of print hql. In the second sentence, the query English field can be displayed. If the first sentence is equal to Chinese, it will not be displayed, but no error will be displayed. The corresponding database records under these two conditions should show the same. Why doesn't Chinese work?
Reply

Use magic Report

0

Threads

14

Posts

13.00

Credits

Newbie

Rank: 1

Credits
13.00

 China

Post time: 2020-3-28 21:45:02
| Show all posts
What database and what database tools do you use?
Reply

Use magic Report

2

Threads

9

Posts

6.00

Credits

Newbie

Rank: 1

Credits
6.00

 China

 Author| Post time: 2020-3-29 18:15:01
| Show all posts
SQL server
Reply

Use magic Report

2

Threads

9

Posts

6.00

Credits

Newbie

Rank: 1

Credits
6.00

 China

 Author| Post time: 2020-3-29 19:15:01
| Show all posts
Use hibernate!
Reply

Use magic Report

0

Threads

14

Posts

13.00

Credits

Newbie

Rank: 1

Credits
13.00

 China

Post time: 2020-3-30 22:15:01
| Show all posts
Do you use the Enterprise Manager to execute the query?
Reply

Use magic Report

2

Threads

9

Posts

6.00

Credits

Newbie

Rank: 1

Credits
6.00

 China

 Author| Post time: 2020-4-1 01:15:01
| Show all posts
hql and sql are written differently! I did not interview in SQL server
Reply

Use magic Report

2

Threads

9

Posts

6.00

Credits

Newbie

Rank: 1

Credits
6.00

 China

 Author| Post time: 2020-4-2 16:45:01
| Show all posts
Select * from GIIS_QUERY_CONFIG where FUNC_NAME = 'Query the weather in the specified city'
Select * from GIIS_QUERY_CONFIG where TABLE_NAME = 'SWeather'
Write this form in SQL, the query records are the same. And it can be executed.
Reply

Use magic Report

0

Threads

14

Posts

13.00

Credits

Newbie

Rank: 1

Credits
13.00

 China

Post time: 2020-4-2 17:00:01
| Show all posts
You try it on the SQL server, it may be hql problem.
Reply

Use magic Report

2

Threads

9

Posts

6.00

Credits

Newbie

Rank: 1

Credits
6.00

 China

 Author| Post time: 2020-4-2 21:30:01
| Show all posts
Does hql support Chinese query? But there is no difference between the two hql of print, and the Chinese sentence does not suggest an error.
How does hibernate execute where conditions?
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2023|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list