You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@inlong.apache.org by "Zkplo (via GitHub)" <gi...@apache.org> on 2024/09/07 02:01:15 UTC

[I] [Feature][SDK] Transform SQL supports the conversion between characters and ASCII [inlong]

Zkplo opened a new issue, #11045:
URL: https://github.com/apache/inlong/issues/11045

   ### Description
   
   - parent issue #10796 
   - FlinkSql Official Description: https://nightlies.apache.org/flink/flink-docs-master/docs/dev/table/functions/systemfunctions/
   
   ASCII(string): Returns the numeric value of the first character of string. Returns NULL if string is NULL.
   CHR(integer): Returns the ASCII character having the binary equivalent to integer. If integer is larger than 255, we will get the modulus of integer divided by 255 first, and returns CHR of the modulus. Returns NULL if integer is NULL.
   
   ### Use case
   
   ```
   ASCII('a') -> 97
   ASCII(null) -> null
   
   chr(97) -> 'a'
   chr(353) -> 'a'
   chr(null) -> null
   ```
   
   ### Are you willing to submit PR?
   
   - [X] Yes, I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@inlong.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] [Feature][SDK] Transform SQL supports the conversion between characters and ASCII [inlong]

Posted by "Zkplo (via GitHub)" <gi...@apache.org>.
Zkplo closed issue #11045: [Feature][SDK] Transform SQL supports the conversion between characters and ASCII
URL: https://github.com/apache/inlong/issues/11045


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@inlong.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org