postgresql - UTF16 hex to text -

-

I have a UTF-16 hex representation, such as "0633064406270645" in Arabic is "سلام".

I would like to convert it to my text equivalent, is there a direct way to do this in postgrasqual?

I can change the UTF code point as follows; Unfortunately it seems that UTF16 is not supported. Any ideas on how to do this in PostgreSQL, the worst case scenario I would write a function? 

  Select Convert_frame (Decoded (E'D8B3D984D8A7D985 ',' HEX '),' UTF8 '); Select "سلام" Convert_frame (decode (E'0633064406270645 ',' hex '),' UTF16 '); Error: Invalid source encoding name "UTF16" ********** Error ****************************************************************************************** ********************************************* Post-Text "MadProp =" Text "> 
 That's right, Postgreat does not support UTF-16. / P> 
 However, it supports:  
  SELECT U & amp;; 0633 \ 0644 \ 0627 \ 0645 \ ' 
 
 but Keep in mind that  Unicode Code Issues  and  UTF-16 Code Entities  are equal in only. In other words, if you have any UTF-16 characters that are more than 16- Bit If you spread the code units, you will have to translate them into this code.

Comments

Post a Comment

Popular posts from this blog

Active Directory Authenticated Proxy Server with Squid or CNTLM -

-
I need to configure a proxy server for a local network that authenticates with Active Directory and gives me access The control list enables you to configure the domain groups within AD. I am using: Static with Squid 2.7: Windows 2008 Server R2 I have followed this guide here: The proxy does not currently ask for any Active Directory accounts, as soon as I add the following lines, it starts denying this connection: ACL localnet proxy_auth Required src 192.168. 0.0 / 24 http_access permission localname This is my squid.conf: pastebin.com/ERuKtirc I see logs and 'none' or 'direct' L It comes together TCP_DENIED message 1415014073.069 1 192.168.0.63 TCP_DENIED / 407/1904 Received / -. None / - Text / html 1415014073.07 9 4 192.168.0.63 TCP_DENIED / 407 2304 Received / - None / - Text / html 1415014073.084 2 192.168.0.63 TCPDAD / 407 1904 Received / - None - - Text / html itemprop = "text"> This proxy returns a 407 request with a browse...
Read more

java - Can't add JTree to JPanel of a JInternalFrame -

-
Image
There are two panels in my JInternalframe. I want to add TopPanel to Jtree to nominate another. But I can not add Jaitari to the top of the panel. Please help me in this piece of code: DefaultMutableTreeNode root = new DefaultMutableTreeNode ("deck"); DefaultMutableTreeNode Item Clubs = New DefaultMutableTreeNode ("Club"); AddAllCard (itemClubs); Root.add (itemClubs); DefaultMutableTreeNode item = New DefaultMutableTreeNode ("Diamonds"); AddAllCard (itemDiamonds); Root.add (itemDiamonds); DefaultMutableTreeNode Itemspads = New DefaultMutableTreeNode ("Spades"); AddAllCard (itemSpades); Root.add (itemSpades); DefaultMutableTreeNode item increases = new DefaultMutableTreeNode ("heart"); AddAllCard (itemHearts); Root.add (itemHearts); Default Trimodel Tree Model = New DefaultTreeModel (Route); Tree = new jetty (tree modal); ScrollPane = new JScrollPane (tree); // scrollPane.setViewportView (tree); . ScrollPane.getViewport () add (tr...
Read more

c - The joining operator ";" in my shell isn't working properly -

-
I have written a simple shell in C, and I ""; The operator is working properly, the user typing command will be 1; Command2 and Shell execute the first command in the command line followed by the second command. However, it seems that, for whatever reason, it is executing only the second order. Why does anyone have an idea? This special section of my code is: four * next = strchr (cmd, ';'); While (next! = Null) {/ * 'next' number ';' * / * Next = '\ 0'; Input = run (CMD, input, first, 0); CMD = next + 1; Next = strchr (CMD, ';'); First = 0; } Your code is working for me just to handle the corner case The condition is added. Please check the code below. four * next = strchr (cmd, ';'); While (next! = Null) {/ * 'next' number ';' * / * Next = '\ 0'; Input = run (CMD, input, first, 0); Printf ("% s \ n", CMD); CMD = next + 1; Next = strchr (CMD, ';'); If (NULL == Next) {i...
Read more