Hello,
Using PostgreSQL 9.2.1 on Windows, I am facing a strange character set issue
with a UTF-8 database.
Maybe this is expected, but want to be sure that I am not missing something.
On Windows, I have created a database with:
ENCODING = 'UTF-8'
LC_COLLATE = 'English_United States.1252'
Sebastien FLAESCH writes:
> - I can use UTF-8 string constants in my queries.
> - I can pass UTF-8 data to the database with parameterized queries.
> - I can fetch UTF-8 data from the database.
> - I can create db object names with UTF-8 characters.
> But the db object names must be specified wit
Tom,
I don't think so because the pg_class schema table shows an empty relation name
for the table created without double quoted identifier containing UTF-8 chars.
Seb
On 10/11/2012 04:03 PM, Tom Lane wrote:
Sebastien FLAESCH writes:
- I can use UTF-8 string constants in my queries.
- I can
On 2012-10-05, Anton Gavazuk wrote:
> Hi dear community,
>
> Have probably quite simple task but cannot find the solution,
>
> Imagine the table A with 2 columns start and end, data type is date
>
> start end
> 01 dec. 10 dec
> 11 dec. 13 dec
> 17 dec. 19 dec
> .
>
> If I
On 2012-10-04, air wrote:
> I have a CTE that takes top left and bottom right latitude/longitude values
> along with a start and end date and it then calculates the amount of user
> requests that came from those coordinates per hourly intervals between the
> given start and end date. However, I wa
