Tried select to_ascii('capo','LATIN1'), to_ascii('çapo','LATIN1') and the results are different....
Add a comment |
1 Answer 1
Look here.
CREATE FUNCTION to_ascii(bytea, name) RETURNS text STRICT AS 'to_ascii_encname' LANGUAGE internal; and then just use it like this:
SELECT to_ascii(convert_to('Übermeier', 'latin1'), 'latin1'); answered Mar 18, 2009 at 17:06
Milen A. Radev
63.2k2222 gold badges111111 silver badges112112 bronze badges
Sign up to request clarification or add additional context in comments.
Comments
- The Overflow Blog
-
-
- Featured on Meta
-
-
-
Related
Hot Network Questions
- Bivouacs made by the homeless
- Determining PL for NPCs with no attacks
- Think inside the box
- Using TikZ with a command only defined on second pass
- Rumor that Socrates helped Euripides with his plays?
- What was the main point of disagreement between Bergson and Einstein?
- How to model cutouts on the top of a toaster?
- Approximate set of finite Lebesgue measure by finite union of open intervals
- How do we see the whole observable universe?
- LED chaser 555 timer in astable works only when shorted
- The Optimal Way
- Assuming that production isn't a problem, what would be the easiest antimatter element to store and contain?
- DC voltage measurement using microcontroller
- Is Bayesian ordinal logistic regression (OLR) a better choice than conventional OLR when certain cells have a small number of observations (<10)?
- Are there any general expectations for the outputs of a deterministic process?
- What was J. J. Connington's mistake about the telephone-bell in “The Case With Nine Solutions”?
- Is self deception the only way to get out of internal contradictions if the contradictions are unsolvable? what are some other methods one can use
- Advice for approaching a co-advisor
- Does this study need a power analysis?
- What are the criteria for "bad faith" questions?
- What term describes a person who always remains ill?
- How to get cash (in Bangkok) with no bank card or passport
- How do entangled particles stay correlated if they do not interact with each other at measurement?
- Calculating two highest maximum values of field in QGIS
lang-sql