数据仓库服务 GaussDB(DWS)-字符处理函数和操作符:convert_to(string text, dest_encoding name)

时间:2025-02-12 15:05:09

convert_to(string text, dest_encoding name)

描述:将字符串转化为dest_encoding的编码格式。

返回值类型:bytea

示例:

 1 2 3 4 5 6 7 8 910
SELECT convert_to('some text', 'UTF8');      convert_to---------------------- \x736f6d652074657874(1 row)SELECT convert_to('database', 'gbk');     convert_to-------------------- \x6461746162617365(1 row)
support.huaweicloud.com/sqlreference-dws/dws_06_0030.html