10 More Discussions You Might Find Interesting
1. Red Hat
am running the following code on a RHEL 6.6 box to list which charsets are loaded and which are available:
my @list = Encode->encodings();
my @all_encodings = Encode->encodings(":all");
... (3 Replies)
Discussion started by: Fundix
2. UNIX for Dummies Questions & Answers
I'm facing an issue when i ssh to a router and exporting the output to a txt file.
ssh email@example.com -a | tee file.txt
Closing the connection and opening the .txt file. There are strange 'domino's' appearing here and there. See the screenshot below.
... (2 Replies)
Discussion started by: Antonio Fargas
3. Shell Programming and Scripting
My control file looks like:
INTO TABLE MK9210_PROD_DL.MK9210_PROD_EG_6
FIELDS TERMINATED BY '|'
,PATIENT INTEGER EXTERNAL
,COMEG CHAR... (4 Replies)
Discussion started by: Pratiksha Mehra
4. UNIX for Advanced & Expert Users
Hello Experts, please help to provide any insight as I am facing issue migrating java application from hpux to redhat. The java program is using InputStreamReader to read a file without specifying any charset parameter.
However, in new Linux Redhat 5.6 environent, when reading a file that... (1 Reply)
Discussion started by: sonic_air
5. UNIX for Dummies Questions & Answers
what's the relationship among locale, glibc, charset, charmap and fonts?
why locale needs to be generated by glibc? how?
what are in the locale-archive file?
and what are in font files? (0 Replies)
Discussion started by: vistastar
6. Shell Programming and Scripting
I'm using a tree command in a script that for me outputs:-
| - - DIRECTORYNAME
However a different user is getting the following output:-
aaa (actually with an umlat above them) DIRECTORYNAME
I'm not sure where this could be coming from, any ideas anyone? (0 Replies)
Discussion started by: Bashingaway
7. Shell Programming and Scripting
My objective is to find out the charset using which a file is encoded. (The OS is SunOs)
I have set NLS_LANG to AR8MSWIN1256 and spooled the file.
When viewed the file using vi, I saw the following
I then inserted the line containing these codes in a... (3 Replies)
Discussion started by: sridhar_423
8. Shell Programming and Scripting
Can anyonr please tell how to load a binary file through SQLLDR.
I have the structure of the binary file in a seperate lb file but I don't know how to feed it to the sqlldr. (0 Replies)
Discussion started by: snowline84
9. Shell Programming and Scripting
Like class loader in java, can we make a function loader in shell script, for this can someone throw some light on how internally bash runs a shell script , what happenes in runtime ...
thanks in advance.. (1 Reply)
Discussion started by: mpsc_sela
10. UNIX for Advanced & Expert Users
How can I find out the charset on a Unix server (SUNOS 5.2)? I tried locale charmap and returned 646. What does 646 mean? If I send an xml file with encoding="utf-8", should the server be able to handle the file, even with special characters in it?
Thanks. (0 Replies)
Discussion started by: iengca
CONVERSION(7) SQL Commands CREATE CONVERSION(7)
CREATE CONVERSION - define a new encoding conversion
CREATE [ DEFAULT ] CONVERSION name
FOR source_encoding TO dest_encoding FROM funcname
CREATE CONVERSION defines a new conversion between character set encodings. Also, conversions that are marked DEFAULT can be used for auto-
matic encoding conversion between client and server. For this purpose, two conversions, from encoding A to B and from encoding B to A, must
To be able to create a conversion, you must have EXECUTE privilege on the function and CREATE privilege on the destination schema.
The DEFAULT clause indicates that this conversion is the default for this particular source to destination encoding. There should be
only one default encoding in a schema for the encoding pair.
name The name of the conversion. The conversion name can be schema-qualified. If it is not, the conversion is defined in the current
schema. The conversion name must be unique within a schema.
The source encoding name.
The destination encoding name.
The function used to perform the conversion. The function name can be schema-qualified. If it is not, the function will be looked up
in the path.
The function must have the following signature:
integer, -- source encoding ID
integer, -- destination encoding ID
cstring, -- source string (null terminated C string)
internal, -- destination (fill with a null terminated C string)
integer -- source string length
) RETURNS void;
Use DROP CONVERSION to remove user-defined conversions.
The privileges required to create a conversion might be changed in a future release.
To create a conversion from encoding UTF8 to LATIN1 using myfunc:
CREATE CONVERSION myconv FOR 'UTF8' TO 'LATIN1' FROM myfunc;
CREATE CONVERSION is a PostgreSQL extension. There is no CREATE CONVERSION statement in the SQL standard.
ALTER CONVERSION [alter_conversion(7)], CREATE FUNCTION [create_function(7)], DROP CONVERSION [drop_conversion(7)]
SQL - Language Statements 2010-05-14 CREATE CONVERSION(7)