oracle - Oracle 11g,12c LOWER TURKISH 字符问题
问题描述
sql:
select LOWER('I') FROM DUAL
Result:
LOWER('I')
i
select nls_lower('I',nls_sort='xturkish') from dual;
Result:
nls_lower('I')
ı
我想使用 的lower
功能,hibernate
我怎样才能将它转换为 Oracle 的nls_lower
?
解决方案
nls_lower
是具有可选 NLS 参数的区域设置相关 SQL 函数的一部分
行为取决于全球化支持约定的所有 SQL 函数都允许指定 NLS 参数。这些功能是:
- TO_CHAR
- 迄今为止
- TO_NUMBER
- NLS_UPPER
- NLS_LOWER
- NLS_INITCAP
- NLSSORT
所以用它代替lower
土耳其语支持
推荐阅读
- raspberry-pi - How to install Bcrypt on a 64bit Raspberry PI?
- android - Android Studio 4.0 error; Cause: invalid type code: 3A
- python - Python Script POST Body Containing CRLF Characters and Malformed Headers. HTTP Request Smuggling
- python - Taking a list as input from user
- c++ - (Why) can we assign non-static class members to static variables in initialization?
- python - How do I add to a section in a line in JSON (python)?
- python - FFMPEG Streaming to twitch low bitrate
- audiokit - Is there a way to control dry/wet balance of AKOperationEffect?
- image - How to decode Base64 String to Image file with flutter
- sql - IF 在本机查询中带有参数