postgresql - How do you change the character encoding of a postgres database? -

-

i have database set default character set sql_ascii. want switch unicode. there easy way that?

  1. dump database
  2. drop database,
  3. create new database different encoding
  4. reload data.

make sure client encoding set correctly during this.

source: http://archives.postgresql.org/pgsql-novice/2006-03/msg00210.php


Comments

Post a Comment

Popular posts from this blog

c# - Is it possible to remove an existing registration from Autofac container builder? -

-
something along lines: builder.registertype<mytype>().as<itype>(); builder.registertype<mytype2>().as<itype>(); builder.deregistertype<mytype>().as<itype>() var container = builder.build(); var types = container.resolve<ienumerable<itype>>(); assert.istrue(types.count == 1); assert.istrue(types[0].gettype == typeof(mytype2)); scenario: go through bunch of assemblies , go register types want make sure have 1 implementation of given type. need before create container. track on own nice if autofac me bit. this cannot done directly using containerbuilder , unless start on new one. mind you, having first built container should able construct new container filtering away unwanted types , reusing registrations first container. this: ... var container = builder.build(); builder = new containerbuilder(); var components = container.componentregistry.registrations .where(cr => cr.activator.limittype != typ...
Read more

asp.net - RadAsyncUpload in code behind, how to? -

-
my problem is, nothing happens, code behind doesn't fire...maybe point me in right direction. possible or totaly wrong here? default.aspx: <telerik:radprogressmanager runat="server" id="radprogressmanager1" /> <telerik:radasyncupload runat="server" id="asyncupload1" /> <telerik:radprogressarea runat="server" id="radprogressarea1" /> default.aspx.cs: protected void asyncupload1_fileuploaded(object sender, fileuploadedeventargs e) { const string relativepath = "~/uploads/"; var filename = e.file.filename; var parentid = convert.toint32(gridview1.selectedvalue); var filesize = convert.toint32(e.file.contentlength); var physicalsavepath = mappath(relativepath) + filename; //store file info in database var app_filesadapter = new app_filestableadapter(); app_filesadapter.insert(filename, relativep...
Read more