Postgresql collation -

-

is posible define collation connection? i'm connecting postgresql server 9.3 via php pdo. know can set collation server, column or define in select statement need connection.

thank you.

i don't think can set collation in connection. however, if need change collation data representation , not ordering, can add following parameters connection string:

lc_monetary (string) sets locale use formatting monetary amounts, example to_char family of functions. acceptable values system-dependent; see section 22.1 more information. if variable set empty string (which default) value inherited execution environment of server in system-dependent way.

lc_numeric (string) sets locale use formatting numbers, example to_char family of functions. acceptable values system-dependent; see section 22.1 more information. if variable set empty string (which default) value inherited execution environment of server in system-dependent way.

lc_time (string) sets locale use formatting dates , times, example to_char family of functions. acceptable values system-dependent; see section 22.1 more information. if variable set empty string (which default) value inherited execution environment of server in system-dependent way.

source: client connection locale , formatting (postgres 9.3 documentation)


Comments

Post a Comment

Popular posts from this blog

python - matpltolib navigation toolbar edit curves and parameters line color automatically changes issue -

-
let's consider axis has multiple lines colors such blue, green, yellow, red, magenta, cyan etc. when user selects curve , presses ok without changing anything, automatically yellow , green colors changed slight difference. this happens yellow, green colors. import sys import numpy np matplotlib.figure import figure import matplotlib matplotlib.use("qt4agg") matplotlib.rcparams['backend.qt4']='pyside' matplotlib.backends.backend_qt4agg import figurecanvasqtagg figurecanvas, navigationtoolbar2qtagg navigationtoolbar matplotlib.figure import figure import pyside pyside import qtgui, qtcore class myapp(qtgui.qmainwindow): def __init__(self, parent=none): qtgui.qmainwindow.__init__(self, parent) self.widget = qtgui.qwidget() self.fig = figure((5.0, 4.0), dpi=100) self.canvas = figurecanvas(self.fig) self.toolbar = navigationtoolbar(self.can...
Read more

node.js - Nodejs javascript implementation of PBEWithMD5AndTripleDES/CBC/PKCS5Padding -

-
in order write simple nodejs app talking server written in java have implement following functionality nodejs. public class crypto { cipher decipher; byte[] salt = { (byte) 0x01, (byte) 0x02, (byte) 0x03, (byte) 0x04, (byte) 0x0a, (byte) 0x0b, (byte) 0x0c, (byte) 0x0d }; int iterationcount = 10; public crypto(string pass) { try { keyspec keyspec = new pbekeyspec(pass.tochararray(), salt, iterationcount); secretkey key = secretkeyfactory.getinstance( "pbewithmd5andtripledes").generatesecret(keyspec); ecipher = cipher.getinstance("pbewithmd5andtripledes/cbc/pkcs5padding"); algorithmparameterspec paramspec = new pbeparameterspec(salt, iterationcount); decipher.init(cipher.decrypt_mode, key, paramspec); } catch (exception ex) { } } } i use crypto module of nodejs var crypto = require('crypto'), pass = new buffer(wek), salt = new buffer([0x01, 0x02, 0x03, 0x0...
Read more