Featured Posts

[Informasi Harga][feat1]

Change Database Character Set in Oracle 12c

February 16, 2023

 Change Database Character Set in Oracle 12c



For the previous version, the official method for character set is using CSSCAN and ASALTER utility. So, from Oracle Database 12c, Oracle introduced a new tool called Database Migration Assistant for Unicode referred in Doc ID 1272374.1. But we have two cases; the first one is applied only if the new character set is a strict superset of the current character set. If not, you will have the “ORA-12712: new character set must be a superset of old character set” error. And then Oracle introduces the “INTERNAL_USE” option. The two option avoid to you to use a traditional method by using Export/Import or Data Pump Utility.
To change the Character set, you use the statement as follow:
ALTER DATABASE CHARACTER SET new_character_set;
E.g.: ALTER DATABASE CHARACTER SET WE8MSWIN1252;
Note: You must notice that this action cannot be rolled back, but you re apply the same method to back to the previous character set. However, it’s advised to do a full backup of your database before applying the change.
We want now to change the NLS_CHARACTERSET from WE8MSWIN1252 to AL32UTF8;
SQL> select * from NLS_DATABASE_PARAMETERS
  2  where parameter='NLS_CHARACTERSET';
PARAMETER                      VALUE
----------------------------- ----------------------------------------
NLS_CHARACTERSET               WE8MSWIN1252

To change the database character set, perform the following steps:
1.       Properly Shut down the database:
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
2.       Start the Database as restricted session

SQL> startup restrict
ORACLE instance started.

Total System Global Area 5167382528 bytes
Fixed Size                  3842808 bytes
Variable Size            1090522376 bytes
Database Buffers         4060086272 bytes
Redo Buffers               12931072 bytes
Database mounted.
Database opened.
3.       Change the Character Set
SQL> alter database character set AL32UTF8;
alter database character set AL32UTF8
*
ERROR at line 1:
ORA-12712: new character set must be a superset of old character set
Don’t worry, in our case, the new Character Set is not a superset of the old one. In this case we must use the below:
SQL> alter database character set INTERNAL_USE AL32UTF8;
Database altered.
4.       Once the Character Set is changed, you must properly restart the database.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 5167382528 bytes
Fixed Size                  3842808 bytes
Variable Size            1090522376 bytes
Database Buffers         4060086272 bytes
Redo Buffers               12931072 bytes
Database mounted.
Database opened.

5.       Verify that the new Character set is applied
SQL> select * from NLS_DATABASE_PARAMETERS
  2  where parameter='NLS_CHARACTERSET';
PARAMETER
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_CHARACTERSET
AL32UTF8

Sort array of objects by one property

February 15, 2023

 Use usort, here's an example adapted from the manual:

function cmp($a, $b) {
    return strcmp($a->name, $b->name);
}

usort($your_data, "cmp");

You can also use any callable as the second argument. Here are some examples:

  • Using anonymous functions (from PHP 5.3)

      usort($your_data, function($a, $b) {return strcmp($a->name, $b->name);});
    
  • From inside a class

      usort($your_data, array($this, "cmp")); // "cmp" should be a method in the class
    
  • Using arrow functions (from PHP 7.4)

      usort($your_data, fn($a, $b) => strcmp($a->name, $b->name));
    

Also, if you're comparing numeric values, fn($a, $b) => $a->count - $b->count as the "compare" function should do the trick, or, if you want yet another way of doing the same thing, starting from PHP 7 you can use the Spaceship operator, like this: fn($a, $b) => $a->count <=> $b->count.

How to configure PostgreSQL to accept all incoming connections WINDOWS

January 26, 2023

1. SETTING PG_HBA.CONF

Just use 0.0.0.0/0.

host    all             all             0.0.0.0/0            md5

Make sure the listen_addresses in postgresql.conf (or ALTER SYSTEM SET) allows incoming connections on all available IP interfaces.

listen_addresses = '*'

After the changes you have to reload the configuration. One way to do this is execute this SELECT as a superuser.

SELECT pg_reload_conf();

Note: to change listen_addresses, a reload is not enough, and you have to restart the server.


2. RESTART POSTGRES SERVICES

  • Press Windows key + R, 'RUN' box will appear.
  • Type services. ...
  • Services window will open, search for postgresql-13. ...
  • Right-click on the postgresql-13 and click on the restart option.
  • The services will restart now.
  • This is how we can restart PostgreSQL services in windows machines.
3. Open Windows Firewall Port
AND ADD POSTGRESQL INTO WINDOWS FIREWALL INBOUNDS RULE

Does your PostgreSQL database run on a Windows server with firewall enabled?

In this case you can just turn off the firewall for a first test in Control Panel -> Systems and Security -> Windows Firewall -> Turn Windows Firewall on or off.

As an alternative you can go to Control Panel -> Systems and Security ->  Windows Firewall -> Allow a program or feature through Windows Firewall -> Advanced Settings -> New Rule:

  • Rule Type: Port 
  • TCP or UDP: TCP
  • Specific local ports: 5432
  • Action: Allow the connection
  • When does this rule apply: Domain, Private and Public (all three checked)
  • Name: "PostgreSQL Incoming"

Array and string offset access syntax with curly braces is deprecated

September 12, 2022

 It's really simple to fix the issue, however keep in mind that you should fork and commit your changes for each library you are using in their repositories to help others as well.

Let's say you have something like this in your code:

$str = "test";
echo($str{0});

since PHP 7.4 curly braces method to get individual characters inside a string has been deprecated, so change the above syntax into this:

$str = "test";
echo($str[0]);

Fixing the code in the question will look something like this:

public function getRecordID(string $zoneID, string $type = '', string $name = ''): string
{
    $records = $this->listRecords($zoneID, $type, $name);
    if (isset($records->result[0]->id)) {
        return $records->result[0]->id;
    }
    return false;
}

FIX ERROR : Declaration of MX_Loader should be compatible with CI_Loader After Update To PHP 7

September 12, 2022
After updating 5.6 to PHP 7. I was using HMVC implementation of CodeIgniter and PHP upgrade 
Here I have fixed all issue. Bellow I have given:


1.third party\MX\Lang.php
line=38
public function load($langfile ='', $lang = '', $return = FALSE, $add_suffix = TRUE, $alt_path = '', $_module = '')

2.third party\MX\Loader.php
line=107
public function helper($helper = array())

3.third party\MX\Loader.php
line=124
public function helpers($helpers = array())

4.third party\MX\Loader.php
line=142
public function library($library = '', $params = NULL, $object_name = NULL)

5.third party\MX\Loader.php
line=131
public function language($langfile = array(), $idiom = '', $return = FALSE, $add_suffix = TRUE, $alt_path = '')

6.third party\MX\Loader.php
line=283
public function  &_ci_get_component($component)

Cara Install Firebird Di XAMPP PHP 7

September 12, 2022

Latar Belakang

Recent versions of PHP indeed no longer ship with the interbase package. Instead you can use the Firebird PHP driver, which is a fork and continued development of the interbase package.


1.  Download interbase.dll di link ini

Interbase.dll

2. Ekstrak file lalu pindahkahn ke c://xampp/php/ext

3. Selesai

10 Rekomendasi Harga WIFI EXTENDER Termurah dan Terlaris Harga Original

May 10, 2022


Daftar Harga Wifi Extender Terbaik dan Termurah | Maspaical.com - Carilah Wifi Extender yang bisa digunakan sesuai kebutuhan dan kegunaannya, dalam hal ini maksudnya adalah produk Wifi Extender memiliki kualitas produk yang menjanjikan, sehingga anda tidak akan dirugikan anda juga bisa mendapatkan harga Wifi Extender yang sekiranya memiliki bonus atau special gift saat anda membeli Wifi Extender, sehingga anda bisa mendapatkan diskon lumayan dari pelapak.

Wifi Extender yang ditampilkan disini sangat besar kemungkinannya sudah ready stok, langsung saja dicek daftar harganya dibawah ini. Usahakan foto Wifi Extender yang tercantum di halaman pelapak adalah foto asli atau real, karena banyak pelapak abal-abal yang asal copas foto dari pelapak lain, caranya bisa anda cari di mbah gugel, sehingga anda tidak akan tertipu. jadi carilah foto Wifi Extender yang benar-benar real pic original dari pelapak itu sendiri.



Lihat Wifi Extender yang sudah terjamin high quality dan yang tidak akan mengecewakan. sehingga Wifi Extender yang anda beli bisa untuk anda jual kembali. dapatkan harga Wifi Extender murah dan kalau bisa yang awet agar bisa digunakan untuk waktu jangka panjang. produk Wifi Extender yang anda beli haruslah terbuat dari bahan yang kuat sehingga tidak mudah rusak saat digunakan.

Baca juga : 10 Rekomendasi Harga MOUSE GAMING Termurah dan Terlaris Harga Original

Lihatlah informasi rating pelapak, carilah pelapak yang memiliki good rating, minimal 4 star, sehingga kualitas produk Wifi Extender dan pelayanannya terjamin. Berikut ini adalah list atau daftar harga Wifi Extender terbaru, termantap 2019.



Daftar Harga Wifi Extender

klik nama produk untuk melihat detail barang

Harap konfirmasikan ketersediaan produk Wifi Extender terlebih dahulu, dan cantumkan keterangan Wifi Extender yang anda inginkan, dikarenakan apabila tidak menginformasikan hal tersebut beberapa pelapak akan mengirim produk Wifi Extender dengan tipe yang mungkin tidak anda mengerti dan mereka tidak akan menerima komplain anda.

Selalu cek dan cari informasi tentang Wifi Extender Original Asli dengan Wifi Extender KW atau Palsu sebelum membeli. sementara itulah informasi harga Wifi Extender, atau katalog harga Wifi Extender terbaru di tahun 2019 ini. Semoga anda bisa mendapatkan harga Wifi Extender dengan harga terbaik dan mendapatkan Wifi Extender dengan the best quality.

Tag Pencarian : wifi extender, wifi extender vs booster, wifi extender walmart, wifi extender amazon, wifi extender best buy, wifi extender with ethernet, wifi extender vs mesh, wifi extender xfinity, wifi extender setup, wifi extender vs repeater, wifi extender netgear, wifi extender att, wifi extender app, wifi extender antenna, wifi extender at walmart, wifi extender ac1200, wifi extender ac750, wifi extender att fiber, wifi extender and booster, wifi extender app for android, a wifi extender, does a wifi extender work, is a wifi extender worth it, how a wifi extender works, will a wifi extender help, connecting a wifi extender, does a wifi extender reduce speed, a good wifi extender, buy a wifi extender, make a wifi extender, wifi extender best, wifi extender blinking red, wifi extender box, wifi extender blinking white, wifi extender brands, wifi extender blinking orange, wifi extender bridge mode, wifi extender blinking yellow, wifi extender belkin, b&q wifi extender, b&m wifi extender, b&h wifi extender, b t wifi extender, b hyve wifi extender, best wifi extenders, b and q wifi extender socket, raspberry pi 3 b+ wifi extender, best wifi extender and booster, wifi extender costco, wifi extender cox, wifi extender comcast, wifi extender centurylink, wifi extender causing internet to drop, wifi extender connected but no internet, wifi extender compatible with att, wifi extender compatible with at&t fiber, wifi extender compatible with fios, wifi extender cost, c wifi extender, c crane wifi extender, usb c wifi extender, c spire wifi extender, nokia g-240w-c wifi extender, c'est quoi wifi extender, c'est quoi un wifi extender, best wifi extender booster canada, wifi extender dual band, wifi extender distance, wifi extender doesn't work, wifi extender definition, wifi extender do they work, wifi extender directions, wifi extender drops connection, wifi extender disconnects, wifi extender diy, wifi extender directional antenna, d link wifi extender, d-link wifi extender setup, d'link wifi extender dap 1325 setup, d'link wifi extender dap 1320 setup, d'link wifi extender dap 1610 setup, d-link wifi extender dap-1530 setup, d-link wifi extender not working, d'link wifi extender flashing orange, d'link wifi extender not showing up, d'link wifi extender with ethernet port, wifi extender ethernet, wifi extender eero, wifi extender ethernet input, wifi extender ethernet port, wifi extender external antenna, wifi extender ethernet output, wifi extender explained, wifi extender ebay, wifi extender easy setup, wifi extender exterior, ee wifi extender, wifi e extender, e-shop wifi extender, powerline e wifi extender, fastgate e wifi extender,

SKIP>>

Beli Wifi Extender Online harga murah terbaru 2022 di Tokopedia! ... WiFi Range Extender TP Link RE200 - TPLink RE 200 AC750 Dual Band.Xiaomi Wifi Extender Pro Repeater Amplifier 300Mbps / Penguat Sinyal - Extender Pro · Xiaomi Wifi Extender Pro Repeater Amplifier 300Mbps / Penguat Sinyal - ...Xiaomi Mi Wifi Range Extender Pro Garansi Resmi Mi WIFI Repeater Pro Mi Wifi Amplifier Pro Penguat Sinyal Wifi. Rp143.000 - Rp339.000. 1RB+ terjual.Wifi Repeater atau WiFi extender digunakan untuk memperluas cakupan jaringan Wi-Fi Anda. Perangkat tersebut bekerja dengan menerima sinyal WiFi Anda yang ...Apa Itu WiFi Repeater? ... Dilansir dari halaman HelloTech, WiFi Repeater adalah penguat jaringan yang berfungsi memperluas jangkauan sinyal WiFi.Jual Wifi Range Extender Tplink Terbaru dengan Harga Termurah & Pilihan Terlengkap di Lazada.co.id Bisa COD ✓ Free Ongkir ✓ 100% Asli!The TL-WA855RE range extender expands your router's signal to provide strong and stable WiFi to your home. Watch movies, stream music and listen to your ...Pernahkah kamu merasakan sinyal WiFi yang kamu miliki menjadi lemah di beberapa titik? · WiFi extender sendiri merupakan satu perangkat keras ...Xiaomi Wifi Range Extender or Repeater adalah wifi extender atau repeater yang mempunyai fungsi untuk meningkatkan sinyal router Anda. Caranya cukup mudah, Anda ...

Powered by Blogger.